SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER  view v_Authormodule as

select * From ts_Authorizations
union all
select u.ui_userid,m.mf_projectid,m.mf_moduleid,m.mf_menuid,
  cast(1 as bit),cast(1 as bit),cast(1 as bit),cast(1 as bit),
  cast(1 as bit),cast(1 as bit),cast(1 as bit),cast(1 as bit),
  cast(1 as bit),cast(1 as bit),cast(1 as bit),cast(1 as bit),
  m.mf_menu_auto_id from ts_usersinfo u, ts_modulesfuncinfo m where mf_formmodule=2


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

